package com.opal.modules.costReportForm.mapper.mysql;


import com.opal.modules.costReportForm.entity.CostReportBOther;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public interface CostReportOtherMapper {

    @Select("SELECT acronym FROM `opal_dept` where pk_dept=#{pkDept}")
    public String getDeptNano(@Param("pkDept") String pkDept);

    //【授权费\顾问\其他】 查询
    List<CostReportBOther> getCalculateOtherChargesZtTable(String costReportId);

    //【授权费\顾问\其他】 根据成本报告删除
    int deleteCostReportBotherByCostReportId(String costReportId);

    //【授权费\顾问\其他】 添加
    int costReportBotherAdd(CostReportBOther costReportBotherExpenses);
}